package com.analyst.mapper;

import com.analyst.entity.Job;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Delete;


public interface SqlJobMapper extends BaseMapper<Job> {

    @Delete("DROP TABLE IF EXISTS sql_job")
    void dropTable();

    @Delete("create table sql_job\n" +
            "(\n" +
            "\tid int not null auto_increment,\n" +
            "\t`sql_string` text null,\n" +
            "\tbegin_time datetime null,\n" +
            "\tend_time datetime null,\n" +
            "\tconstraint sql_job_pk\n" +
            "\t\tprimary key (id)\n" +
            ");\n" +
            "\n")
    void createTable();
}
